package migrate

import "sale-admin/config/mysql"

//Script2 表字段名修改
func (MigrateFunc) Script2() error {
	//ma_activity_data
	mysql.NewDB().Exec("alter table `ma_activity_data` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_activity_data` change column `ActivityID` `activity_id` bigint NOT NULL COMMENT '引用的模板ID'")
	mysql.NewDB().Exec("alter table `ma_activity_data` change column `Title` `title` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户活动标题'")
	mysql.NewDB().Exec("alter table `ma_activity_data` change column `Content` `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户资料内容'")
	mysql.NewDB().Exec("alter table `ma_activity_data` change column `Phone` `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号'")
	mysql.NewDB().Exec("alter table `ma_activity_data` change column `AddTime` `add_time` datetime NOT NULL COMMENT '添加时间'")
	mysql.NewDB().Exec("alter table `ma_activity_data` change column `RedemptionCode` `redemption_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '兑换码'")
	//ma_activity
	mysql.NewDB().Exec("alter table `ma_activity` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_activity` change column `Title` `title` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '活动标题'")
	mysql.NewDB().Exec("alter table `ma_activity` change column `Content` `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '控件内容'")
	mysql.NewDB().Exec("alter table `ma_activity` change column `ImagePath` `image_path` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片地址'")
	mysql.NewDB().Exec("alter table `ma_activity` change column `Color` `color` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '颜色值'")
	mysql.NewDB().Exec("alter table `ma_activity` change column `Status` `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0开启 1关闭'")
	mysql.NewDB().Exec("alter table `ma_activity` change column `Deleted` `deleted` tinyint(1) DEFAULT '0' COMMENT '0正常 1删除'")
	//ma_ad_source_detail
	mysql.NewDB().Exec("alter table `ma_ad_source_detail` change column `ID` `id` int unsigned NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_ad_source_detail` change column `SourceID` `source_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '素材库名称'")
	mysql.NewDB().Exec("alter table `ma_ad_source_detail` change column `PathName` `path_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '素材库路径'")
	mysql.NewDB().Exec("alter table `ma_ad_source_detail` change column `Name` `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL")
	mysql.NewDB().Exec("alter table `ma_ad_source_detail` change column `Deleted` `deleted` tinyint(1) NOT NULL DEFAULT '0'")
	mysql.NewDB().Exec("alter table `ma_ad_source_detail` change column `CheckMd5` `check_md5` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	//ma_ad_source
	mysql.NewDB().Exec("alter table `ma_ad_source` change column `ID` `id` int unsigned NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_ad_source` change column `SourceName` `source_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '素材库名称'")
	mysql.NewDB().Exec("alter table `ma_ad_source` change column `PathName` `path_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '素材库路径'")
	mysql.NewDB().Exec("alter table `ma_ad_source` change column `Deleted` `deleted` tinyint(1) NOT NULL DEFAULT '0'")
	mysql.NewDB().Exec("alter table `ma_ad_source` change column `UserID` `user_id` bigint DEFAULT NULL COMMENT '用户ID'")
	//ma_ad
	mysql.NewDB().Exec("alter table `ma_ad` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_ad` change column `Name` `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '广告名称'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '投放机器标识ID'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `LaunchScope` `launch_scope` text CHARACTER SET utf8mb4 NOT NULL COMMENT '投放范围'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `EndTime` `end_time` date NOT NULL COMMENT '结束时间'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `Position` `position` tinyint(1) NOT NULL DEFAULT '0' COMMENT '广告位置 0 前屏 1 后屏 2待机页'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `FilePath` `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '上传文件地址'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `CheckStatus` `check_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核状态 0未审核 1通过 2未通过'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `UseStatus` `use_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '投放状态:0 等待开始 1投放中 2投放结束'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `Deleted` `deleted` tinyint(1) NOT NULL DEFAULT '0'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `StartTime` `start_time` date DEFAULT NULL COMMENT '开始投放'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `ModifyTime` `modify_time` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_ad` change column `CheckMd5` `check_md5` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '视频校验MD5'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `AddTime` `add_time` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_ad` change column `PlayTime` `play_time` bigint DEFAULT NULL COMMENT '广告播放频率'")
	mysql.NewDB().Exec("alter table `ma_ad` change column `Duration` `duration` bigint NOT NULL DEFAULT '30'")
	//ma_ai_service_face_count
	mysql.NewDB().Exec("alter table `ma_ai_service_face_count` change column `ID` `id` bigint NOT NULL COMMENT '设备权限ID'")
	mysql.NewDB().Exec("alter table `ma_ai_service_face_count` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '售货识别ID 序列号'")
	mysql.NewDB().Exec("alter table `ma_ai_service_face_count` change column `RobotName` `robot_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '机器人名称'")
	mysql.NewDB().Exec("alter table `ma_ai_service_face_count` change column `AddTime` `add_time` datetime NOT NULL COMMENT '人脸数据添加时间'")
	mysql.NewDB().Exec("alter table `ma_ai_service_face_count` change column `FaceCount` `face_count` int NOT NULL COMMENT '人脸统计数'")
	mysql.NewDB().Exec("alter table `ma_ai_service_face_count` change column `StartTime` `start_time` datetime NOT NULL COMMENT '统计起始时间'")
	mysql.NewDB().Exec("alter table `ma_ai_service_face_count` change column `EndTime` `end_time` datetime NOT NULL COMMENT '统计结束时间'")
	mysql.NewDB().Exec("alter table `ma_ai_service_face_count` change column `FaceCount0` `face_count0` bigint NOT NULL DEFAULT '0'")
	mysql.NewDB().Exec("alter table `ma_ai_service_face_count` change column `FaceCount1` `face_count1` bigint NOT NULL DEFAULT '0'")
	mysql.NewDB().Exec("alter table `ma_ai_service_face_count` change column `FaceCount2` `face_count2` bigint NOT NULL DEFAULT '0'")
	//ma_close_containner_log
	mysql.NewDB().Exec("alter table `ma_close_containner_log` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_close_containner_log` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器识别码'")
	mysql.NewDB().Exec("alter table `ma_close_containner_log` change column `ContainerNum` `container_num` bigint NOT NULL COMMENT '货道号'")
	mysql.NewDB().Exec("alter table `ma_close_containner_log` change column `AddTime` `add_time` datetime NOT NULL")
	//ma_email
	mysql.NewDB().Exec("alter table `ma_email` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_email` change column `Url` `url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '推送内容'")
	mysql.NewDB().Exec("alter table `ma_email` change column `AddTime` `add_time` datetime DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_email` change column `Object` `object` bigint DEFAULT NULL")
	//ma_emergency_user
	mysql.NewDB().Exec("alter table `ma_emergency_user` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_emergency_user` change column `Name` `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '通知人'")
	mysql.NewDB().Exec("alter table `ma_emergency_user` change column `Phone` `phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '联系电话'")
	mysql.NewDB().Exec("alter table `ma_emergency_user` change column `Email` `email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮箱地址'")
	mysql.NewDB().Exec("alter table `ma_emergency_user` change column `Deleted` `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除0:正常 1删除'")
	//ma_emergency
	mysql.NewDB().Exec("alter table `ma_emergency` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_emergency` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器唯一识别ID'")
	mysql.NewDB().Exec("alter table `ma_emergency` change column `Type` `type` bigint NOT NULL COMMENT '三级告警类型(一级和二级不需要存入)：1001.退款 1002低库存 1003 系统异常 1004 关舱超时 1005 初始化报错'")
	mysql.NewDB().Exec("alter table `ma_emergency` change column `AddTime` `add_time` datetime NOT NULL COMMENT '添加时间'")
	mysql.NewDB().Exec("alter table `ma_emergency` change column `EmergencyUserInfo` `emergency_user_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '通知人名称'")
	mysql.NewDB().Exec("alter table `ma_emergency` change column `Deleted` `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1删除 0正常'")
	//ma_event_question
	mysql.NewDB().Exec("alter table `ma_event_question` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_event_question` change column `EventType` `event_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '事件类型的含义'")
	mysql.NewDB().Exec("alter table `ma_event_question` change column `AddTime` `add_time` datetime NOT NULL COMMENT '添加时间'")
	mysql.NewDB().Exec("alter table `ma_event_question` change column `Content` `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL")
	//ma_event_type
	mysql.NewDB().Exec("alter table `ma_event_type` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_event_type` change column `Name` `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '事件类型的含义'")
	mysql.NewDB().Exec("alter table `ma_event_type` change column `AddTime` `add_time` datetime NOT NULL COMMENT '添加时间'")
	//ma_event
	mysql.NewDB().Exec("alter table `ma_event` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_event` change column `SalesID` `sales_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器识别码'")
	mysql.NewDB().Exec("alter table `ma_event` change column `RobotName` `robot_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器名称'")
	mysql.NewDB().Exec("alter table `ma_event` change column `Date` `date` date NOT NULL COMMENT '记录日期'")
	mysql.NewDB().Exec("alter table `ma_event` change column `EventType` `event_type` bigint NOT NULL COMMENT '事件类型：1软件 2硬件 3其他'")
	mysql.NewDB().Exec("alter table `ma_event` change column `EeventDesc` `event_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '事件问题描述'")
	mysql.NewDB().Exec("alter table `ma_event` change column `AffectedTime` `affected_time` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '影响的运营时长'")
	mysql.NewDB().Exec("alter table `ma_event` change column `Move` `move` tinyint(1) DEFAULT '0' COMMENT '机器是否出场 0否 1是'")
	mysql.NewDB().Exec("alter table `ma_event` change column `MoveDesc` `move_desc` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '出场描述'")
	mysql.NewDB().Exec("alter table `ma_event` change column `Emergency` `emergency` tinyint(1) DEFAULT NULL COMMENT '突发事件：0否 1是'")
	mysql.NewDB().Exec("alter table `ma_event` change column `EmergencyDesc` `emergency_desc` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '突发事件描述'")
	mysql.NewDB().Exec("alter table `ma_event` change column `ShopID` `shop_id` bigint NOT NULL COMMENT '商户ID'")
	mysql.NewDB().Exec("alter table `ma_event` change column `AddTime` `add_time` datetime NOT NULL")
	mysql.NewDB().Exec("alter table `ma_event` change column `Location` `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '省市区上传'")
	mysql.NewDB().Exec("alter table `ma_event` change column `Event` `event` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '事件问题'")
	mysql.NewDB().Exec("alter table `ma_event` change column `AffectedTimeMill` `affected_time_mill` bigint DEFAULT NULL COMMENT '影响运营的时长，毫秒'")
	//ma_goods_click
	mysql.NewDB().Exec("alter table `ma_goods_click` change column `ID` `id` bigint NOT NULL COMMENT '设备权限ID'")
	mysql.NewDB().Exec("alter table `ma_goods_click` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '售货识别ID 序列号'")
	mysql.NewDB().Exec("alter table `ma_goods_click` change column `RobotName` `robot_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '机器人名称'")
	mysql.NewDB().Exec("alter table `ma_goods_click` change column `AddTime` `add_time` datetime NOT NULL COMMENT '人脸数据添加时间'")
	mysql.NewDB().Exec("alter table `ma_goods_click` change column `ClickNum` `click_num` bigint NOT NULL COMMENT '人脸统计数'")
	mysql.NewDB().Exec("alter table `ma_goods_click` change column `StartTime` `start_time` datetime DEFAULT NULL COMMENT '统计起始时间'")
	mysql.NewDB().Exec("alter table `ma_goods_click` change column `EndTime` `end_time` datetime NOT NULL COMMENT '统计结束时间'")
	mysql.NewDB().Exec("alter table `ma_goods_click` change column `GoodsID` `goods_id` bigint DEFAULT NULL COMMENT '所属机器的商品ID'")
	//ma_goods_info
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsID` `goods_id` int NOT NULL AUTO_INCREMENT COMMENT '商品ID'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `ID` `id` bigint unsigned NOT NULL COMMENT '设备权限ID'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `ClassID` `class_id` bigint DEFAULT NULL COMMENT '类目ID'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `Price` `price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '商品价格'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsName1` `goods_name1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名称1'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsDescription1` `goods_description1` varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品描述1'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsImage` `goods_image` blob COMMENT '商品图片地址'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsStatus` `goods_status` int unsigned NOT NULL DEFAULT '0' COMMENT '商品状态（0-上架 1-缺货 2-下架）'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `TotalSales` `total_sales` int(32) unsigned zerofill NOT NULL DEFAULT '00000000000000000000000000000000'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsCode` `goods_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '国标编码'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `UseRC` `use_rc` int unsigned DEFAULT '0' COMMENT '使用兑换码支付（0-不使用，1-使用）'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsName2` `goods_name2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品名称2'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsDescription2` `goods_description2` varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品描述2'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsName3` `goods_name3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品名称3'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsDescription3` `goods_description3` varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品描述3'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `Deleted` `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '软删除 0正常 1删除'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `CodeImage` `code_image` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `IsAuth` `is_auth` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是正版授权 0不是 1是'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `Price1` `price1` decimal(10,2) DEFAULT NULL COMMENT '下划线价格'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsDetail` `goods_detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '商品详情'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `ShowTag` `show_tag` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '展示标签'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `GoodsType` `goods_type` bigint DEFAULT '1' COMMENT '商品类别:1 实物商品 2导流商品 3虚拟类商品'")
	mysql.NewDB().Exec("alter table `ma_goods_info` change column `Spring` `spring` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '弹簧规格'")
	//ma_goods_multi
	mysql.NewDB().Exec("alter table `ma_goods_multi` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_goods_multi` change column `GoodsName` `goods_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名称'")
	mysql.NewDB().Exec("alter table `ma_goods_multi` change column `MultiGoods` `multi_goods` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '多规格商品'")
	mysql.NewDB().Exec("alter table `ma_goods_multi` change column `GoodsDetail` `goods_detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品详情'")
	mysql.NewDB().Exec("alter table `ma_goods_multi` change column `SalesID` `sales_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器识别码'")
	mysql.NewDB().Exec("alter table `ma_goods_multi` change column `RobotName` `robot_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器名称'")
	mysql.NewDB().Exec("alter table `ma_goods_multi` change column `AddTime` `add_time` datetime NOT NULL COMMENT '添加时间'")
	mysql.NewDB().Exec("alter table `ma_goods_multi` change column `MultiSort` `multi_sort` bigint DEFAULT NULL COMMENT '多商品规格排序值'")
	//ma_goods
	mysql.NewDB().Exec("alter table `ma_goods` change column `ClassID` `class_id` int NOT NULL AUTO_INCREMENT COMMENT '类目ID'")
	mysql.NewDB().Exec("alter table `ma_goods` change column `ID` `id` bigint unsigned NOT NULL COMMENT '设备权限ID'")
	mysql.NewDB().Exec("alter table `ma_goods` change column `ClassName` `class_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '类目名称1'")
	mysql.NewDB().Exec("alter table `ma_goods` change column `ClassDescription` `class_description` varchar(4095) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类品描述3'")
	mysql.NewDB().Exec("alter table `ma_goods` change column `ClassStutas` `class_status` int unsigned NOT NULL DEFAULT '2' COMMENT '商品状态（0-上架 1-缺货 2-下架）'")
	mysql.NewDB().Exec("alter table `ma_goods` change column `AddTime` `add_time` datetime DEFAULT NULL COMMENT '添加时间'")
	mysql.NewDB().Exec("alter table `ma_goods` change column `TotalSales` `total_sales` int(32) unsigned zerofill NOT NULL DEFAULT '00000000000000000000000000000000'")
	mysql.NewDB().Exec("alter table `ma_goods` change column `Deleted` `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '软删除 0正常 1删除'")
	//ma_order_details
	mysql.NewDB().Exec("alter table `ma_order_details` change column `ID` `id` bigint NOT NULL COMMENT '订单ID'")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `UserName` `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `AddTime` `add_time` datetime NOT NULL")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `ModifyTime` `modify_time` datetime DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `PaymentID` `payment_id` bigint DEFAULT NULL COMMENT '0-微信；\r\n1-支付宝；\r\n2-支付宝人脸；\r\n3-刷卡\r\n4-好邻居\r\n5-兑换码'")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `WechatCreatResult` `wechat_creat_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `AlipayCreatResult` `alipay_creat_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `WechatQueryResult` `wechat_query_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `AlipayQueryResult` `alipay_query_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `QueryResult` `query_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `SuccessResult` `success_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `CloseResult` `close_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `PaymentAmount` `payment_amount` decimal(10,2) DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `JuheWechatCreatResult` `juhe_wechat_creat_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `JuheAlipayCreatResult` `juhe_alipay_creat_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_details` change column `Times` `times` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	//ma_order_notify
	mysql.NewDB().Exec("alter table `ma_order_notify` change column `ID` `id` int DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_order_notify` change column `OutTradeNo` `out_trade_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_order_notify` change column `Source` `source` varchar(255) DEFAULT NULL COMMENT 'Ali -- 支付宝 WeChat -- 微信'")
	mysql.NewDB().Exec("alter table `ma_order_notify` change column `AddTime` `add_time` datetime DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_order_notify` change column `Msg` `msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci")
	//ma_order_refund
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `ID` `id` bigint NOT NULL")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `SalesID` `sales_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `PaymentAmount` `payment_amount` decimal(10,2) unsigned NOT NULL")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `ReFundPaymentAmount` `refund_payment_amount` decimal(10,2) unsigned zerofill NOT NULL DEFAULT '00000000.00'")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `OutTradeNo` `out_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `OutReFundNo` `out_re_fund_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `AddTime` `add_time` datetime DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `AliPayResult` `ali_pay_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `WeChatResult` `we_chat_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `AliPayQueryResult` `ali_pay_query_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `WeChatQueryResult` `we_chat_query_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `Type` `type` int NOT NULL COMMENT '0-受理失败\r\n1-已受理\r\n2-已退款'")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `PayStatus` `pay_status` bigint DEFAULT NULL COMMENT '0-微信,1-支付宝,2-支付宝人脸,3-刷卡'")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `Reason` `reason` tinyint(1) DEFAULT NULL COMMENT '0-网络异常订单支付未出货 1-货品出错 2-商品质量问题 3-其他'")
	mysql.NewDB().Exec("alter table `ma_order_refund` change column `Remarks` `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci")
	//ma_order
	mysql.NewDB().Exec("alter table `ma_order` change column `OrderID` `order_id` int unsigned NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_order` change column `ID` `id` bigint NOT NULL COMMENT '商户ID'")
	mysql.NewDB().Exec("alter table `ma_order` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '机器标识ID'")
	mysql.NewDB().Exec("alter table `ma_order` change column `AddTime` `add_time` datetime NOT NULL COMMENT '订单生成时间'")
	mysql.NewDB().Exec("alter table `ma_order` change column `RobotName` `robot_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器名称'")
	mysql.NewDB().Exec("alter table `ma_order` change column `OutTradeNo` `out_trade_no` varchar(50) NOT NULL COMMENT '订单号'")
	mysql.NewDB().Exec("alter table `ma_order` change column `ReFunTradeNo` `refund_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '退款交易号'")
	mysql.NewDB().Exec("alter table `ma_order` change column `OrderStatus` `order_status` tinyint(1) NOT NULL COMMENT '0-未初始化\r\n1-创建成功\r\n2-支付成功\r\n3-未支付\r\n4-出货成功\r\n5-出货失败\r\n6-退款\r\n7-错误'")
	mysql.NewDB().Exec("alter table `ma_order` change column `End` `end` tinyint(1) NOT NULL COMMENT '0-正在进行\r\n1-已结束'")
	mysql.NewDB().Exec("alter table `ma_order` change column `PaymentID` `payment_id` tinyint DEFAULT NULL COMMENT '1-微信 2-支付宝 3支付宝人脸；\r\n3-刷卡\r\n4-好邻居 5 - 兑换码 6 大兴支付 7 赠送'")
	mysql.NewDB().Exec("alter table `ma_order` change column `Areas1` `areas1` bigint DEFAULT NULL COMMENT '省级ID'")
	mysql.NewDB().Exec("alter table `ma_order` change column `Areas2` `areas2` bigint DEFAULT NULL COMMENT '市ID'")
	mysql.NewDB().Exec("alter table `ma_order` change column `Areas3` `areas3` bigint DEFAULT NULL COMMENT '商场ID'")
	mysql.NewDB().Exec("alter table `ma_order` change column `Areas4` `areas4` bigint DEFAULT NULL COMMENT '自定义标签ID'")
	mysql.NewDB().Exec("alter table `ma_order` change column `EndOutTradeNo` `end_out_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_order` change column `CountData` `count_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL")
	mysql.NewDB().Exec("alter table `ma_order` change column `PaymentAmount` `payment_amount` decimal(10,2) DEFAULT '0.00' COMMENT '订单金额'")
	mysql.NewDB().Exec("alter table `ma_order` change column `ClassIDList` `class_id_list` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '商品类目列表'")
	mysql.NewDB().Exec("alter table `ma_order` change column `GoodIDList` `good_id_list` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '商品编号列表'")
	mysql.NewDB().Exec("alter table `ma_order` change column `ContainerNumList` `container_num_list` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '货柜编号列表'")
	mysql.NewDB().Exec("alter table `ma_order` change column `ModifyTime` `modify_time` datetime DEFAULT NULL COMMENT '修改时间'")
	mysql.NewDB().Exec("alter table `ma_order` change column `Remarks` `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '订单备注'")
	mysql.NewDB().Exec("alter table `ma_order` change column `ErrorCode` `error_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_order` change column `LogMsg` `log_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_order` change column `OrigialOutTradeNo` `origial_out_trade_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	//ma_payment_alipay
	mysql.NewDB().Exec("alter table `ma_payment_alipay` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_payment_alipay` change column `PaymentID` `payment_id` bigint NOT NULL")
	mysql.NewDB().Exec("alter table `ma_payment_alipay` change column `ShopID` `shop_id` bigint NOT NULL DEFAULT '0' COMMENT '绑定id，大道管理员分配给商户的id'")
	mysql.NewDB().Exec("alter table `ma_payment_alipay` change column `AliPayAppID` `ali_pay_app_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '支付宝AppID'")
	mysql.NewDB().Exec("alter table `ma_payment_alipay` change column `AliPayPrivateKey` `ali_pay_private_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '支付宝密钥'")
	mysql.NewDB().Exec("alter table `ma_payment_alipay` change column `Deleted` `deleted` tinyint(1) DEFAULT '0'")
	mysql.NewDB().Exec("alter table `ma_payment_alipay` change column `Name` `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	//ma_payment_dx
	mysql.NewDB().Exec("alter table `ma_payment_dx` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_payment_dx` change column `PaymentID` `payment_id` bigint NOT NULL")
	mysql.NewDB().Exec("alter table `ma_payment_dx` change column `ShopID` `shop_id` bigint NOT NULL DEFAULT '0' COMMENT '绑定id，大道管理员分配给商户的id'")
	mysql.NewDB().Exec("alter table `ma_payment_dx` change column `Name` `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL")
	mysql.NewDB().Exec("alter table `ma_payment_dx` change column `DxAppID` `dx_app_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '聚合支付密码'")
	mysql.NewDB().Exec("alter table `ma_payment_dx` change column `DxAppKey` `dx_app_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0'")
	mysql.NewDB().Exec("alter table `ma_payment_dx` change column `DxSellerID` `dx_seller_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '大兴收款账户'")
	mysql.NewDB().Exec("alter table `ma_payment_dx` change column `DxMerchantID` `dx_merchant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '大兴商铺号'")
	mysql.NewDB().Exec("alter table `ma_payment_dx` change column `DxShopID` `dx_shop_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '大兴商场号'")
	mysql.NewDB().Exec("alter table `ma_payment_dx` change column `Deleted` `deleted` tinyint(1) DEFAULT '0'")
	//ma_payment_jh
	mysql.NewDB().Exec("alter table `ma_payment_jh` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_payment_jh` change column `PaymentID` `payment_id` bigint NOT NULL")
	mysql.NewDB().Exec("alter table `ma_payment_jh` change column `ShopID` `shop_id` bigint NOT NULL DEFAULT '0' COMMENT '绑定id，大道管理员分配给商户的id'")
	mysql.NewDB().Exec("alter table `ma_payment_jh` change column `JhMerchantNum` `jh_merchant_num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '聚合商户号'")
	mysql.NewDB().Exec("alter table `ma_payment_jh` change column `JhApiKey` `jh_api_key` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '聚合支付密码'")
	mysql.NewDB().Exec("alter table `ma_payment_jh` change column `Deleted` `deleted` tinyint(1) DEFAULT '0'")
	mysql.NewDB().Exec("alter table `ma_payment_jh` change column `Name` `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	//ma_payment_wechat
	mysql.NewDB().Exec("alter table `ma_payment_wechat` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_payment_wechat` change column `PaymentID` `payment_id` bigint NOT NULL")
	mysql.NewDB().Exec("alter table `ma_payment_wechat` change column `ShopID` `shop_id` bigint NOT NULL DEFAULT '0' COMMENT '绑定id，大道管理员分配给商户的id'")
	mysql.NewDB().Exec("alter table `ma_payment_wechat` change column `WeChatmchID` `we_chat_mch_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '微信支付商户号 PartnerID'")
	mysql.NewDB().Exec("alter table `ma_payment_wechat` change column `WeChatAppID` `we_chat_app_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '微信公众号AppID'")
	mysql.NewDB().Exec("alter table `ma_payment_wechat` change column `WeChatAppKey` `we_chat_app_key` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '微信支付密钥'")
	mysql.NewDB().Exec("alter table `ma_payment_wechat` change column `Deleted` `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0正常1删除'")
	mysql.NewDB().Exec("alter table `ma_payment_wechat` change column `Name` `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	//ma_payment
	mysql.NewDB().Exec("alter table `ma_payment` change column `ID` `id` int NOT NULL AUTO_INCREMENT COMMENT '支付方式id，比如'")
	mysql.NewDB().Exec("alter table `ma_payment` change column `PayName` `pay_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支付名称'")
	mysql.NewDB().Exec("alter table `ma_payment` change column `AddTime` `add_time` datetime NOT NULL COMMENT '添加时间'")
	mysql.NewDB().Exec("alter table `ma_payment` change column `UseStatus` `use_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '分配状态 0未分配 1已分配'")
	mysql.NewDB().Exec("alter table `ma_payment` change column `UsedCount` `used_count` bigint NOT NULL DEFAULT '0' COMMENT '商户使用量'")
	mysql.NewDB().Exec("alter table `ma_payment` change column `Status` `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '使用状态：0正常 1停用'")
	//ma_person_info_bama
	mysql.NewDB().Exec("alter table `ma_person_info_bama` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_person_info_bama` change column `Name` `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称'")
	mysql.NewDB().Exec("alter table `ma_person_info_bama` change column `City` `city` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '年级'")
	mysql.NewDB().Exec("alter table `ma_person_info_bama` change column `Phone` `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电话'")
	mysql.NewDB().Exec("alter table `ma_person_info_bama` change column `RedemptionCode` `redemption_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '兑换码'")
	mysql.NewDB().Exec("alter table `ma_person_info_bama` change column `AddTime` `add_time` datetime NOT NULL COMMENT '注册时间'")
	//ma_person_info_look
	mysql.NewDB().Exec("alter table `ma_person_info_look` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_person_info_look` change column `Phone` `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电话'")
	mysql.NewDB().Exec("alter table `ma_person_info_look` change column `RedemptionCode` `redemption_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '兑换码'")
	mysql.NewDB().Exec("alter table `ma_person_info_look` change column `AddTime` `add_time` datetime NOT NULL COMMENT '注册时间'")
	mysql.NewDB().Exec("alter table `ma_person_info_look` change column `Content` `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '问卷内容，使用son字符串格式存入'")
	//ma_person_info
	mysql.NewDB().Exec("alter table `ma_person_info` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_person_info` change column `Name` `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称'")
	mysql.NewDB().Exec("alter table `ma_person_info` change column `Grade` `grade` varchar(30) NOT NULL COMMENT '年级：1小学、2初中、3高中、4大学'")
	mysql.NewDB().Exec("alter table `ma_person_info` change column `Phone` `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电话'")
	mysql.NewDB().Exec("alter table `ma_person_info` change column `RedemptionCode` `redemption_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '兑换码'")
	mysql.NewDB().Exec("alter table `ma_person_info` change column `GradeDetail` `grade_detail` tinyint(1) NOT NULL DEFAULT '0' COMMENT '(1 到 6代表 ：一年级、二年级、三年级...六年级 ) (1-3 初一、初二、初三)(1-3 高一、高二、高三)'")
	//ma_physical_info
	mysql.NewDB().Exec("alter table `ma_physical_info` change column `ID` `id` int unsigned NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_physical_info` change column `Msg` `msg` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号'")
	mysql.NewDB().Exec("alter table `ma_physical_info` change column `Age` `age` bigint NOT NULL COMMENT '年龄'")
	mysql.NewDB().Exec("alter table `ma_physical_info` change column `Sex` `sex` tinyint(1) NOT NULL COMMENT '性别 1男 2女 '")
	mysql.NewDB().Exec("alter table `ma_physical_info` change column `AddTime` `add_time` datetime NOT NULL")
	mysql.NewDB().Exec("alter table `ma_physical_info` change column `Type` `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1点击 2创单 3支付 4 点击空白（非商品）'")
	mysql.NewDB().Exec("alter table `ma_physical_info` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL")
	//ma_redemption_code
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `ID` `id` bigint unsigned NOT NULL COMMENT '设备权限ID'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `RedemptionCode` `redemption_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '兑换码内容'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `Value` `value` decimal(10,2) NOT NULL COMMENT '兑换码价值'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `ExchangeValue` `exchange_value` decimal(10,2) DEFAULT NULL COMMENT '兑换商品价值'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '售货识别ID 序列号'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `RobotName` `robot_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '机器人名称'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `ClassID` `class_id` bigint DEFAULT NULL COMMENT '类目ID'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `GoodsID` `goods_id` bigint DEFAULT NULL COMMENT '商品ID'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `OutTradeNo` `out_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '订单编号'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `AddTime` `add_time` datetime DEFAULT NULL COMMENT '添加时间'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `UsageTime` `usage_time` datetime DEFAULT NULL COMMENT '使用时间'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `ExpirationTime` `expiration_time` datetime NOT NULL COMMENT '失效时间'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `RedemptionState` `redemption_state` int NOT NULL COMMENT '0-失效\r\n1-未使用\r\n2-已使用'")
	mysql.NewDB().Exec("alter table `ma_redemption_code` change column `BrandName` `brand_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '品牌方名称'")
	//ma_redemption_log
	mysql.NewDB().Exec("alter table `ma_redemption_log` change column `ID` `id` int NOT NULL")
	mysql.NewDB().Exec("alter table `ma_redemption_log` change column `Value` `value` decimal(10,2) NOT NULL")
	mysql.NewDB().Exec("alter table `ma_redemption_log` change column `Num` `num` bigint NOT NULL")
	mysql.NewDB().Exec("alter table `ma_redemption_log` change column `AddTime` `add_time` datetime NOT NULL")
	mysql.NewDB().Exec("alter table `ma_redemption_log` change column `ExpirationTime` `expiration_time` datetime DEFAULT NULL")
	//ma_robot_back_apk
	mysql.NewDB().Exec("alter table `ma_robot_back_apk` change column `Route` `route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_back_apk` change column `VersionCode` `version_code` int NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_back_apk` change column `Describe` `describe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci")
	mysql.NewDB().Exec("alter table `ma_robot_back_apk` change column `Name` `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_back_apk` change column `AddTime` `add_time` datetime NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_back_apk` change column `Auth` `auth` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上传人'")
	//ma_robot_config
	mysql.NewDB().Exec("alter table `ma_robot_config` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_robot_config` change column `Type` `type` bigint NOT NULL COMMENT '配置类型'")
	mysql.NewDB().Exec("alter table `ma_robot_config` change column `Object` `object` bigint NOT NULL COMMENT '报告对象'")
	mysql.NewDB().Exec("alter table `ma_robot_config` change column `RobotName` `robot_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报告配置，可以配置多台机器'")
	mysql.NewDB().Exec("alter table `ma_robot_config` change column `AddTime` `add_time` datetime DEFAULT NULL COMMENT '配置时间'")
	mysql.NewDB().Exec("alter table `ma_robot_config` change column `ObjectName` `object_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	//ma_robot_error_log_pallets
	mysql.NewDB().Exec("alter table `ma_robot_error_log_pallets` change column `ID` `id` bigint unsigned NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log_pallets` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log_pallets` change column `AddTime` `add_time` datetime DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log_pallets` change column `OutTradeNo` `out_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '错误订单号'")
	mysql.NewDB().Exec("alter table `ma_robot_error_log_pallets` change column `Type` `type` tinyint(1) DEFAULT NULL COMMENT '类型'")
	mysql.NewDB().Exec("alter table `ma_robot_error_log_pallets` change column `Result` `result` tinyint(1) DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log_pallets` change column `OriginaImagePath` `origina_image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log_pallets` change column `InputImagePath` `input_image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log_pallets` change column `ErrorTimer` `error_timer` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log_pallets` change column `Log` `log` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci")
	//ma_robot_error_log
	mysql.NewDB().Exec("alter table `ma_robot_error_log` change column `ID` `id` bigint unsigned NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log` change column `SalesID` `sales_id` varchar(50) NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log` change column `AddTime` `add_time` datetime DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log` change column `LogMsg` `log_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci")
	mysql.NewDB().Exec("alter table `ma_robot_error_log` change column `ErrorCode` `error_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_error_log` change column `OutTradeNo` `out_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '错误订单号'")
	mysql.NewDB().Exec("alter table `ma_robot_error_log` change column `ContainerNum` `container_num` bigint DEFAULT NULL COMMENT '货道号'")
	//ma_robot_report_log
	mysql.NewDB().Exec("alter table `ma_robot_report_log` change column `ID` `id` bigint NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_robot_report_log` change column `Url` `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '链接访问地址'")
	mysql.NewDB().Exec("alter table `ma_robot_report_log` change column `Type` `type` bigint NOT NULL COMMENT '报告类型'")
	mysql.NewDB().Exec("alter table `ma_robot_report_log` change column `RobotName` `robot_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报告机器'")
	mysql.NewDB().Exec("alter table `ma_robot_report_log` change column `Object` `object` bigint NOT NULL COMMENT '报告对象'")
	mysql.NewDB().Exec("alter table `ma_robot_report_log` change column `StartTime` `start_time` date DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_report_log` change column `EndTime` `end_time` date DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_report_log` change column `AddTime` `add_time` datetime DEFAULT NULL")
	//ma_robot_report
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `RobotName` `robot_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '机器名称'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `Date` `date` date NOT NULL COMMENT '日期'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `SalesID` `sales_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '机器识别码'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `ShopID` `shop_id` bigint NOT NULL COMMENT '商户ID'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `Areas3` `areas3` bigint NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `total_task_duration` `total_task_duration` bigint NOT NULL DEFAULT '0' COMMENT '任务时长，单位毫秒'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `total_task_odometer` `total_task_odometer` bigint NOT NULL DEFAULT '0' COMMENT '任务里程,单位厘米'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `total_charging_duration` `total_charging_duration` bigint NOT NULL DEFAULT '0' COMMENT '充电时长，单位秒'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `total_idle_duration` `total_idle_duration` bigint NOT NULL DEFAULT '0' COMMENT '闲置时长, 单位秒'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `event` `event` bigint NOT NULL DEFAULT '0' COMMENT '事件'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `exit_num` `exit_num` bigint NOT NULL DEFAULT '0' COMMENT '出场次数'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `emergency` `emergency` bigint NOT NULL DEFAULT '0' COMMENT '突发事件'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `operation_duration` `operation_duration` bigint NOT NULL DEFAULT '0' COMMENT '运营时长，单位毫秒'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `GMV` `gmv` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'GMV'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `MyPaymentAmount` `my_payment_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '实付金额'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `DisCountAmount` `dis_count_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '优惠金额'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `MyRefundOrderAmount` `my_refund_order_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退款金额'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `facecount` `facecount` bigint NOT NULL DEFAULT '0' COMMENT '曝光量'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `ScreenClickNum` `screen_click_num` bigint NOT NULL DEFAULT '0' COMMENT '屏幕点击量'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `ClickNum` `click_num` bigint NOT NULL DEFAULT '0' COMMENT '商品点击量'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `MyStartOrderCount` `my_start_order_count` bigint NOT NULL DEFAULT '0' COMMENT '创单笔数'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `MySuccessOrderCount` `my_success_order_count` bigint NOT NULL DEFAULT '0' COMMENT '支付笔数'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `MyNotPayOrderCount` `my_not_pay_order_count` bigint NOT NULL DEFAULT '0' COMMENT '未支付笔数'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `MyRefundOrderCount` `my_refund_order_count` bigint NOT NULL DEFAULT '0' COMMENT '退款笔数'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `PayNum` `pay_num` bigint NOT NULL DEFAULT '0' COMMENT '支付人数'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `ClickRate` `click_rate` float NOT NULL DEFAULT '0' COMMENT '点击率'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `PayRate` `pay_rate` float NOT NULL DEFAULT '0' COMMENT '支付率'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `CreateRate` `create_rate` float NOT NULL DEFAULT '0' COMMENT '创单率'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `total_task_run_count` `total_task_run_count` bigint NOT NULL DEFAULT '0' COMMENT '任务次数'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `facecount0` `facecount0` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `facecount1` `facecount1` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `facecount2` `facecount2` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `RefundRate` `refund_rate` float(255,0) DEFAULT NULL COMMENT '退款率'")
	mysql.NewDB().Exec("alter table `ma_robot_report` change column `MyGiveAmount` `my_give_amount` decimal(10,2) DEFAULT NULL COMMENT '抽奖赠送'")
	//ma_robot_sales_info
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '售货识别ID'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `GoodsID` `goods_id` bigint DEFAULT NULL COMMENT '商品ID'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `GoodsInventory` `goods_inventory` int unsigned NOT NULL DEFAULT '0' COMMENT '商品存货'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `GoodsMaxInventory` `goods_max_inventory` int unsigned NOT NULL DEFAULT '0' COMMENT '商品最高存货'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `ContainerFloor` `container_floor` int(2) unsigned zerofill NOT NULL DEFAULT '00' COMMENT '货柜楼层'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `ContainerNum` `container_num` int(2) unsigned zerofill NOT NULL DEFAULT '00' COMMENT '货柜编号'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `AddTime` `add_time` datetime DEFAULT NULL COMMENT '创建时间'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `ClassID` `class_id` bigint DEFAULT NULL COMMENT '类目ID'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `GoodsStatus` `goods_status` int unsigned NOT NULL DEFAULT '2' COMMENT '商品状态（0-上架 1-缺货 2-下架）'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `ContainerType` `container_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '单双货道 0无 1单 2双'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `Sort` `sort` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `ContainerStatus` `container_status` int unsigned NOT NULL DEFAULT '1' COMMENT '货柜状态【0-下架 1-上架】'")
	mysql.NewDB().Exec("alter table `ma_robot_sales_info` change column `ContainerUseStatus` `container_use_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1正常 2禁用'")
	//ma_robot_update_apk
	mysql.NewDB().Exec("alter table `ma_robot_update_apk` change column `Route` `route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_update_apk` change column `VersionCode` `version_code` int NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_update_apk` change column `AddTime` `add_time` datetime NOT NULL")
	mysql.NewDB().Exec("alter table `ma_robot_update_apk` change column `Describe` `describe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci")
	mysql.NewDB().Exec("alter table `ma_robot_update_apk` change column `Name` `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL")
	//ma_robot
	mysql.NewDB().Exec("alter table `ma_robot` change column `RobotID` `robot_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增唯一机器ID'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `ID` `id` bigint unsigned NOT NULL COMMENT '商户ID'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '售货识别ID 序列号'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `RobotType` `robot_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机器人类型'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `RobotName` `robot_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '机器人名称'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `AddTime` `add_time` datetime NOT NULL COMMENT '设备添加时间'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Activation` `activation` int unsigned DEFAULT '0' COMMENT '是否已激活'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `OnLine` `on_line` int(2) unsigned zerofill DEFAULT '00' COMMENT '是否在线'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `LastReportedTime` `last_reported_time` datetime DEFAULT NULL COMMENT '设备最后上报时间'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `PaymentMethod` `payment_method` int unsigned DEFAULT '0' COMMENT '支付方式:0000-无【0】0001-微信二维码【1】0010-支付宝二维码【2】0100-支付宝人脸【4】1000-刷卡【8】10000-好邻居支付【16】'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Phone` `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `PaymentType1` `payment_type1` tinyint(1) DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `PaymentType2` `payment_type2` tinyint(1) DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `PaymentType3` `payment_type3` tinyint(1) DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `PaymentType4` `payment_type4` tinyint(1) DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Payment1` `payment1` tinyint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Payment2` `payment2` tinyint(1) DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Payment3` `payment3` tinyint(1) DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Payment4` `payment4` tinyint(1) DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Areas1` `areas1` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Areas2` `areas2` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Areas3` `areas3` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Areas4` `areas4` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_robot` change column `IP` `ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'IP地址'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Remark` `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Deleted` `deleted` tinyint(1) DEFAULT '0' COMMENT '0正常 1删除'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `AiFaceMultiple` `ai_face_multiple` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '人流统计系数'")
	mysql.NewDB().Exec("alter table `ma_robot` add column `Switch` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机器关键位置开关'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Switch` `switch` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '机器关键位置开光'")
	mysql.NewDB().Exec("alter table `ma_robot` change column `Areas5` `areas5` bigint DEFAULT NULL")
	//ma_sale_info_log_detail
	mysql.NewDB().Exec("alter table `ma_sale_info_log_detail` change column `ID` `id` bigint NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_sale_info_log_detail` change column `SalesID` `sales_id` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL")
	mysql.NewDB().Exec("alter table `ma_sale_info_log_detail` change column `GoodsID` `goods_id` bigint NOT NULL DEFAULT '0' COMMENT '商品ID'")
	mysql.NewDB().Exec("alter table `ma_sale_info_log_detail` change column `GoodsName` `goods_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名称'")
	mysql.NewDB().Exec("alter table `ma_sale_info_log_detail` change column `PreNum` `pre_num` int NOT NULL DEFAULT '0' COMMENT '操作前数量'")
	mysql.NewDB().Exec("alter table `ma_sale_info_log_detail` change column `LastNum` `last_num` bigint NOT NULL DEFAULT '0' COMMENT '操作后数量'")
	mysql.NewDB().Exec("alter table `ma_sale_info_log_detail` change column `ChangeNum` `change_num` bigint NOT NULL DEFAULT '0' COMMENT '变动后数量'")
	mysql.NewDB().Exec("alter table `ma_sale_info_log_detail` change column `AddTime` `add_time` datetime DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_sale_info_log_detail` change column `LogID` `log_id` bigint DEFAULT NULL")
	//ma_sale_info_log
	mysql.NewDB().Exec("alter table `ma_sale_info_log` change column `ID` `id` bigint NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_sale_info_log` change column `AddTime` `add_time` datetime NOT NULL COMMENT '补货时间'")
	mysql.NewDB().Exec("alter table `ma_sale_info_log` change column `Type` `type` bigint NOT NULL COMMENT '补货类型'")
	mysql.NewDB().Exec("alter table `ma_sale_info_log` change column `Num` `num` bigint DEFAULT NULL COMMENT '补货数量'")
	mysql.NewDB().Exec("alter table `ma_sale_info_log` change column `SalesID` `sales_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_sale_info_log` change column `Date` `date` date DEFAULT NULL COMMENT '补货日期'")
	mysql.NewDB().Exec("alter table `ma_sale_info_log` change column `RobotName` `robot_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	//ma_tag
	mysql.NewDB().Exec("alter table `ma_tag` change column `ID` `id` bigint unsigned NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_tag` change column `Level` `level` bigint NOT NULL COMMENT '1-省级 2-市级 3-商场 4-自定义'")
	mysql.NewDB().Exec("alter table `ma_tag` change column `Name` `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL")
	mysql.NewDB().Exec("alter table `ma_tag` change column `AreasMID` `areas_mid` bigint NOT NULL COMMENT '上级ID'")
	mysql.NewDB().Exec("alter table `ma_tag` change column `Deleted` `deleted` tinyint(1) DEFAULT '0' COMMENT '0正常 1删除'")
	mysql.NewDB().Exec("alter table `ma_tag` change column `ShopID` `shop_id` bigint DEFAULT NULL COMMENT '绑定的用户ID'")
	//ma_user_shop_info
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `ID` `id` bigint unsigned NOT NULL COMMENT '唯一ID'")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `MasterID` `master_id` bigint NOT NULL")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `NickName` `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '昵称'")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `UserName` `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名'")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `Phone` `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '联系电话'")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `PaymentsID` `payments_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '支付方式集合'")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `TagThreeID` `tag_three_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '三级标签id'")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `TagFourID` `tag_four_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '四级标签id'")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `RobotsID` `robots_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `Status` `status` tinyint(1) DEFAULT '0' COMMENT '状态 0 正常 1异常'")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `Remark` `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT ''")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `Deleted` `deleted` tinyint(1) DEFAULT '0' COMMENT '0正常 1删除'")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `switch_sms` `switch_sms` tinyint(1) DEFAULT '0' COMMENT '短信开关 0未启用 1 开启 2关闭'")
	mysql.NewDB().Exec("alter table `ma_user_shop_info` change column `switch_wechat` `switch_wechat` tinyint(1) DEFAULT '0' COMMENT '微信开关 0未启用 1 开启 2关闭'")
	//ma_user
	mysql.NewDB().Exec("alter table `ma_user` change column `ID` `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '唯一ID'")
	mysql.NewDB().Exec("alter table `ma_user` change column `UserName` `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名'")
	mysql.NewDB().Exec("alter table `ma_user` change column `PassWord` `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码'")
	mysql.NewDB().Exec("alter table `ma_user` change column `AddTime` `add_time` datetime NOT NULL COMMENT '账号生成时间'")
	mysql.NewDB().Exec("alter table `ma_user` change column `Token` `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '验证令牌'")
	mysql.NewDB().Exec("alter table `ma_user` change column `LoginTime` `login_time` datetime DEFAULT NULL COMMENT '登陆时间'")
	mysql.NewDB().Exec("alter table `ma_user` change column `PermissionLevel` `permission_level` int unsigned NOT NULL DEFAULT '3' COMMENT '用户权限：\r\n0-最高级管理员\r\n1-用户\r\n2-商户\r\n3-ERROR 4子商户'")
	mysql.NewDB().Exec("alter table `ma_user` change column `Deleted` `deleted` tinyint(1) DEFAULT '0' COMMENT '0 正常 1删除'")
	//ma_wechat_rate
	mysql.NewDB().Exec("alter table `ma_wechat_rate` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_wechat_rate` change column `UniqueID` `unique_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '用户唯一标识ID'")
	mysql.NewDB().Exec("alter table `ma_wechat_rate` change column `Type` `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1微信 2支付宝'")
	mysql.NewDB().Exec("alter table `ma_wechat_rate` change column `OutTradeNo` `out_trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '购买订单号'")
	mysql.NewDB().Exec("alter table `ma_wechat_rate` change column `SalesID` `sales_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机器名称'")
	mysql.NewDB().Exec("alter table `ma_wechat_rate` change column `GoodsID` `goods_id` bigint DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_wechat_rate` change column `Count` `count` bigint NOT NULL COMMENT '购买次数'")
	mysql.NewDB().Exec("alter table `ma_wechat_rate` change column `AddTime` `add_time` datetime NOT NULL")
	//ma_wechat_user
	mysql.NewDB().Exec("alter table `ma_wechat_user` change column `ID` `id` int NOT NULL AUTO_INCREMENT")
	mysql.NewDB().Exec("alter table `ma_wechat_user` change column `NickName` `nick_name` blob NOT NULL COMMENT '微信昵称'")
	mysql.NewDB().Exec("alter table `ma_wechat_user` change column `Image` `image` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信头像链接'")
	mysql.NewDB().Exec("alter table `ma_wechat_user` change column `OpenID` `open_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信唯一标识'")
	mysql.NewDB().Exec("alter table `ma_wechat_user` change column `AddTime` `add_time` datetime DEFAULT NULL")
	mysql.NewDB().Exec("alter table `ma_wechat_user` change column `UserID` `user_id` bigint DEFAULT NULL COMMENT '账号ID'")
	mysql.NewDB().Exec("alter table `ma_wechat_user` change column `Status` `status` tinyint(1) DEFAULT '1' COMMENT ' 0未启用 1 开启 2关闭'")
	return nil
}
